/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50722
 Source Host           : localhost:3306
 Source Schema         : room58

 Target Server Type    : MySQL
 Target Server Version : 50722
 File Encoding         : 65001

 Date: 20/10/2022 11:24:31
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for code
-- ----------------------------
DROP TABLE IF EXISTS `code`;
CREATE TABLE `code` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `type` tinyint(4) NOT NULL DEFAULT '0',
  `openid` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20041 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of code
-- ----------------------------
BEGIN;
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6401, '56745954', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6402, '91566034', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6403, '17543967', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6404, '56132275', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6405, '81217308', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6406, '21724697', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6407, '91872106', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6408, '18381952', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6409, '62903955', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6410, '47538234', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6411, '98855367', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6412, '17644185', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6413, '72550202', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6414, '43955804', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6415, '61393514', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6416, '81347679', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6417, '43711539', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6418, '54503118', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6419, '19985108', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6420, '68915215', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6421, '66908137', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6422, '68774262', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6423, '45648995', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6424, '84089362', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6425, '65629235', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6426, '33995477', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6427, '98631710', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6428, '98777163', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6429, '83356859', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6430, '81784005', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6431, '82443475', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6432, '49954979', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6433, '68342937', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6434, '79670229', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6435, '91152995', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6436, '28406367', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6437, '78451891', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6438, '43953370', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6439, '33822173', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6440, '98291949', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6441, '35925209', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6442, '79306401', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6443, '89520547', 0, NULL, NULL, 3, NULL);
INSERT INTO `code` (`id`, `code`, `status`, `created_at`, `updated_at`, `type`, `openid`) VALUES (6444, '36505300', 0, NULL, NULL, 3, NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
